﻿use AAL1
GO

-- Bảng Regions
insert into Regions values (N'Miền Bắc')
insert into Regions values (N'Miền Trung')
insert into Regions values (N'Miền Nam')
Go
-- Bảng Citys
insert into Citys values(1, N'Hà Nội')
insert into Citys values(1, N'Hà Tĩnh')
insert into Citys values(2, N'Đà Nẵng')
insert into Citys values(2, N'Huế')
insert into Citys values(3, N'TP Hồ Chí Minh')
insert into Citys values(3, N'Tiền Giang')

-- Bảng StatusOfAccount
insert into StatusOfAccount values ('Active','Active')
insert into StatusOfAccount values ('DeActive','De-Active')
insert into StatusOfAccount values ('Disable','Disable')
-- Bảng Accounts
insert into Accounts values ('headerofficehn1','123456','1/1/2011',1)
insert into Accounts values ('headerofficehn2','123456','1/1/2011',1)
insert into Accounts values ('storekeeperhn','123456','1/1/2011',1)
insert into Accounts values ('headerofficedn1','123456','1/1/2011',1)
insert into Accounts values ('headerofficedn2','123456','1/1/2011',1)
insert into Accounts values ('headerofficedn3','123456','1/1/2011',1)
insert into Accounts values ('storekeeperdn1','123456','1/1/2011',3)
insert into Accounts values ('storekeeperdn2','123456','1/1/2011',1)
insert into Accounts values ('headerofficehcm','123456','1/1/2011',1)
insert into Accounts values ('storekeeperhcm','123456','1/1/2011',1)
insert into Accounts values ('manager','123456','1/1/2011',1)
insert into Accounts values ('coodinator','123456','1/1/2011',1)
insert into Accounts values ('planner','123456','1/1/2011',1)
insert into Accounts values ('employee1','123456','1/1/2011',2)
insert into Accounts values ('employee2','123456','1/1/2011',3)
insert into Accounts values ('employee3','123456','1/1/2011',2)
insert into Accounts values ('employee4','123456','1/1/2011',3)
insert into Accounts values ('employee5','123456','1/1/2011',2)
--
insert into Accounts values ('dealer1','123456','1/1/2011',3)
insert into Accounts values ('dealer2','123456','1/1/2011',2)
insert into Accounts values ('dealer3','123456','1/1/2011',1)
insert into Accounts values ('dealer4','123456','1/1/2011',1)


GO

-- Bảng AccountInformations
--insert into AccountInformations values (1, 'lastname','firstname','1/1/1988', 'address',1, '0123456789','0123456789','abc@gmail.com','notes');
insert into AccountInformations values (1, 'lastname1 firstname1','1/1/1988', 'address',1, '0123456789','0123456789','abc1@gmail.com','notes');
insert into AccountInformations values (2, 'lastname2 firstname2','1/1/1988', 'address',1, '0123456789','0123456789','abc2@gmail.com','notes');
insert into AccountInformations values (3, 'lastname3 firstname3','1/1/1988', 'address',1, '0123456789','0123456789','abc3@gmail.com','notes');

insert into AccountInformations values (4, N'Nguyễn Thị Thanh Huyền 1','1/1/1988', 'address',3, '0123456789','0123456789','abc4@gmail.com','notes');
insert into AccountInformations values (5, N'Nguyễn Thị Thanh Huyền 2','1/1/1988', 'address',3, '0123456789','0123456789','abc5@gmail.com','notes');
insert into AccountInformations values (6, N'Nguyễn Thị Thanh Huyền 3','1/1/1988', 'address',4, '0123456789','0123456789','abc6@gmail.com','notes');

insert into AccountInformations values (7, N'Dương Vĩnh Lộc 1','1/1/1988', 'address',3, '0123456789','0123456789','abc7@gmail.com','notes');
insert into AccountInformations values (8, N'Dương Vĩnh Lộc 2','1/1/1988', 'address',3, '0123456789','0123456789','abc8@gmail.com','notes');

insert into AccountInformations values (9, 'lastname4 firstname5','1/1/1988', 'address',5, '0123456789','0123456789','abc9@gmail.com','notes');
insert into AccountInformations values (10, 'lastname5 firstname5','1/1/1988', 'address',5, '0123456789','0123456789','abc10@gmail.com','notes');

insert into AccountInformations values (11, N'Đào Thanh Phát','1/1/1988', 'address',3, '0123456789','0123456789','abc11@gmail.com','notes');
insert into AccountInformations values (12, N'Hứa Nguyễn Hoài Thương','1/1/1988', 'address',3, '0123456789','0123456789','abc12@gmail.com','notes');
insert into AccountInformations values (13, N'Bùi Văn Minh','1/1/1988', 'address',3, '0123456789','0123456789','abc13@gmail.com','notes');
insert into AccountInformations values (14, 'lastname6 firstname6','1/1/1988', 'address',1, '0123456789','0123456789','abc14@gmail.com','notes');
insert into AccountInformations values (15, 'lastname7 firstname7','1/1/1988', 'address',1, '0123456789','0123456789','abc15@gmail.com','notes');
insert into AccountInformations values (16, 'lastname8 firstname8','1/1/1988', 'address',1, '0123456789','0123456789','abc16@gmail.com','notes');
insert into AccountInformations values (17, 'lastname9 firstname9','1/1/1988', 'address',1, '0123456789','0123456789','abc17@gmail.com','notes');
insert into AccountInformations values (18, 'lastname10 firstname10','1/1/1988', 'address',1, '0123456789','0123456789','abc18@gmail.com','notes');
--
insert into AccountInformations values (19, 'lastname2 firstname2','1/1/1988', 'address',1, '0123456789','0123456789','abc19@gmail.com','notes');
insert into AccountInformations values (20, 'lastname3 firstname3','1/1/1988', 'address',1, '0123456789','0123456789','abc20@gmail.com','notes');
insert into AccountInformations values (21, 'lastname4 firstname4','1/1/1988', 'address',1, '0123456789','0123456789','abc21@gmail.com','notes');
set  Dateformat dmy
GO
insert into AccountInformations values (22, 'lastname5 firstname5','13/1/1988', 'address',1, '0123456789','0123456789','abc22@gmail.com','notes');

-- Bảng Scales
--insert into Scales values ('ten',money, 'mô tả');
insert into Scales values (N'Đại lý nhỏ',50000000, N'Đại lý nhỏ');
insert into Scales values (N'Đại lý vừa',100000000, N'Đại lý vừa');
insert into Scales values (N'Đại lý lớn',200000000, N'Đại lý lớn');
-- select * from Scales where ScaleDealer=N'Đại lý nhỏ'

Go
-- Bảng Dealers
--insert into Dealers values (N'Company name', AccountID, 800000, ScaleID);
insert into Dealers values (N'CTHH ABC', 19, 800000, 1);
insert into Dealers values (N'CTHH CDF', 20, 0, 1);
insert into Dealers values (N'CTHH EFI', 21, 0, 2);
insert into Dealers values (N'CTHH IJH', 22, 0, 2);
GO
-- Bảng PaymentOfDealer

-- Bảng Departments
insert into Departments values(N'Header Office',N'Đảm nhận việc xử lý các đơn đăt hàng cũng như đăng kí của các đại lý');
insert into Departments values(N'Bộ phận điều phối',N'Đảm nhận việc mua hàng cho công ty cũng như điều phối lượng hàng giữa các vùng miền khi có nhu cầu.');
insert into Departments values(N'Quản lý',N'Đảm nhận việc xử lý phê duyệt kế hoạch, cũng như xác nhận việc mua hàng cho công ty...');
insert into Departments values(N'Thủ kho',N'Đảm nhận việc xác nhận việc xuất và nhập kho.');
insert into Departments values(N'Bộ phận lập kế hoạch',N'Đảm nhận việc lập kế hoạch mua hàng cho công ty ...');
GO
--select * from Departments where DepartmentName=N'Quản lý'

-- Bảng Employees
insert into Employees values (1,1)
insert into Employees values (1,2)
insert into Employees values (4,3)
insert into Employees values (1,4)
insert into Employees values (1,5)
insert into Employees values (1,6)
insert into Employees values (4,7)
insert into Employees values (4,8)
insert into Employees values (1,9)
insert into Employees values (4,10)
insert into Employees values (3,11)
insert into Employees values (2,12)
insert into Employees values (5,13)
insert into Employees values (1,14)
insert into Employees values (1,15)
insert into Employees values (2,16)
insert into Employees values (4,17)
insert into Employees values (4,18)


-- Bảng TypeOfAutos
insert into TypeOfAutos values ('P',N'Xe khách',N'Xe Khách - Passenger ...')
insert into TypeOfAutos values ('S',N'Xe SUV',N'Xe thể thao - Sport Utility Vehicle ...')
insert into TypeOfAutos values ('T',N'Xe tải',N'Xe tải - truck ...')
GO

-- Bảng TypesOfWheel
insert into TypesOfWheel values ('PAA','P', N'Lốp loại AA', N'Tính năng lốp loại AA', N'Công nghệ được sử dụng cho lốp loại AA',N'Nội dung tóm tắt lốp loại AA', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('PBB','P', N'Lốp loại BB', N'Tính năng lốp loại BB', N'Công nghệ được sử dụng cho lốp loại BB',N'Nội dung tóm tắt lốp loại BB', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('PCC','P', N'Lốp loại CC', N'Tính năng lốp loại CC', N'Công nghệ được sử dụng cho lốp loại CC',N'Nội dung tóm tắt lốp loại CC', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('PDD','P', N'Lốp loại DD', N'Tính năng lốp loại DD', N'Công nghệ được sử dụng cho lốp loại DD',N'Nội dung tóm tắt lốp loại DD', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')

insert into TypesOfWheel values ('SAA','S', N'Lốp loại AA', N'Tính năng lốp loại AA', N'Công nghệ được sử dụng cho lốp loại AA',N'Nội dung tóm tắt lốp loại AA', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('SBB','S', N'Lốp loại BB', N'Tính năng lốp loại BB', N'Công nghệ được sử dụng cho lốp loại BB',N'Nội dung tóm tắt lốp loại BB', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('SCC','S', N'Lốp loại CC', N'Tính năng lốp loại CC', N'Công nghệ được sử dụng cho lốp loại CC',N'Nội dung tóm tắt lốp loại CC', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('SDD','S', N'Lốp loại DD', N'Tính năng lốp loại DD', N'Công nghệ được sử dụng cho lốp loại DD',N'Nội dung tóm tắt lốp loại DD', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')

insert into TypesOfWheel values ('TAA','T', N'Lốp loại AA', N'Tính năng lốp loại AA', N'Công nghệ được sử dụng cho lốp loại AA',N'Nội dung tóm tắt lốp loại AA', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('TBB','T', N'Lốp loại BB', N'Tính năng lốp loại BB', N'Công nghệ được sử dụng cho lốp loại BB',N'Nội dung tóm tắt lốp loại BB', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('TCC','T', N'Lốp loại CC', N'Tính năng lốp loại CC', N'Công nghệ được sử dụng cho lốp loại CC',N'Nội dung tóm tắt lốp loại CC', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')
insert into TypesOfWheel values ('TDD','T', N'Lốp loại DD', N'Tính năng lốp loại DD', N'Công nghệ được sử dụng cho lốp loại DD',N'Nội dung tóm tắt lốp loại DD', 'http://www.michelin.vn/extension/michelin/design/michelin/images/upload/pattern/20090211_1518331.png')

-- Bảng Speed tính theo km/h
insert into Speed values ('F',80)
insert into Speed values ('G',90)
insert into Speed values ('J',100)
insert into Speed values ('K',110)
insert into Speed values ('L',120)
insert into Speed values ('M',130)
insert into Speed values ('N',140)
insert into Speed values ('P',150)
insert into Speed values ('Q',160)
insert into Speed values ('R',170)
insert into Speed values ('S',180)
insert into Speed values ('T',190)
insert into Speed values ('U',200)
insert into Speed values ('H',210)
insert into Speed values ('V',240)
GO

-- Bảng WheelDetails
insert into WheelDetails values ('PAA225/45R19-001', 'PAA',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R19-002', 'PAA',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R19-003', 'PAA',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R19-004', 'PAA',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R19-005', 'PAA',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('PAA225/45R18-001', 'PAA',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R18-002', 'PAA',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R18-003', 'PAA',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R18-004', 'PAA',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('PAA225/45R18-005', 'PAA',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('PAA225/45R17-001', 'PAA',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R17-002', 'PAA',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R17-003', 'PAA',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('PAA225/45R17-004', 'PAA',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('PAA225/45R17-005', 'PAA',225, 45, 'R', 17, 93, 14, N'..', 50  )

insert into WheelDetails values ('PBB225/45R19-001', 'PBB',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R19-002', 'PBB',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R19-003', 'PBB',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R19-004', 'PBB',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R19-005', 'PBB',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('PBB225/45R18-001', 'PBB',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R18-002', 'PBB',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R18-003', 'PBB',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R18-004', 'PBB',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('PBB225/45R18-005', 'PBB',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('PBB225/45R17-001', 'PBB',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R17-002', 'PBB',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R17-003', 'PBB',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('PBB225/45R17-004', 'PBB',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('PBB225/45R17-005', 'PBB',225, 45, 'R', 17, 93, 14, N'..', 50  )


insert into WheelDetails values ('PCC225/45R19-001', 'PCC',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R19-002', 'PCC',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R19-003', 'PCC',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R19-004', 'PCC',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R19-005', 'PCC',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('PCC225/45R18-001', 'PCC',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R18-002', 'PCC',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R18-003', 'PCC',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R18-004', 'PCC',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('PCC225/45R18-005', 'PCC',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('PCC225/45R17-001', 'PCC',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R17-002', 'PCC',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R17-003', 'PCC',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('PCC225/45R17-004', 'PCC',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('PCC225/45R17-005', 'PCC',225, 45, 'R', 17, 93, 14, N'..', 50  )

insert into WheelDetails values ('TAA225/45R19-001', 'TAA',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R19-002', 'TAA',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R19-003', 'TAA',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R19-004', 'TAA',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R19-005', 'TAA',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('TAA225/45R18-001', 'TAA',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R18-002', 'TAA',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R18-003', 'TAA',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R18-004', 'TAA',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('TAA225/45R18-005', 'TAA',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('TAA225/45R17-001', 'TAA',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R17-002', 'TAA',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R17-003', 'TAA',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('TAA225/45R17-004', 'TAA',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('TAA225/45R17-005', 'TAA',225, 45, 'R', 17, 93, 14, N'..', 50  )

insert into WheelDetails values ('TBB225/45R19-001', 'TBB',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R19-002', 'TBB',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R19-003', 'TBB',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R19-004', 'TBB',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R19-005', 'TBB',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('TBB225/45R18-001', 'TBB',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R18-002', 'TBB',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R18-003', 'TBB',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R18-004', 'TBB',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('TBB225/45R18-005', 'TBB',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('TBB225/45R17-001', 'TBB',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R17-002', 'TBB',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R17-003', 'TBB',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('TBB225/45R17-004', 'TBB',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('TBB225/45R17-005', 'TBB',225, 45, 'R', 17, 93, 14, N'..', 50  )


insert into WheelDetails values ('TCC225/45R19-001', 'TCC',225, 45, 'R', 19, 96, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R19-002', 'TCC',225, 45, 'R', 19, 91, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R19-003', 'TCC',225, 45, 'R', 19, 89, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R19-004', 'TCC',225, 45, 'R', 19, 92, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R19-005', 'TCC',225, 45, 'R', 19, 93, 15, N'..', 50  )

insert into WheelDetails values ('TCC225/45R18-001', 'TCC',225, 45, 'R', 18, 92, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R18-002', 'TCC',225, 45, 'R', 18, 97, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R18-003', 'TCC',225, 45, 'R', 18, 96, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R18-004', 'TCC',225, 45, 'R', 18, 89, 14, N'..', 50  )
insert into WheelDetails values ('TCC225/45R18-005', 'TCC',225, 45, 'R', 18, 95, 14, N'..', 50  )

insert into WheelDetails values ('TCC225/45R17-001', 'TCC',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R17-002', 'TCC',225, 45, 'R', 17, 94, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R17-003', 'TCC',225, 45, 'R', 17, 95, 15, N'..', 50  )
insert into WheelDetails values ('TCC225/45R17-004', 'TCC',225, 45, 'R', 17, 92, 14, N'..', 50  )
insert into WheelDetails values ('TCC225/45R17-005', 'TCC',225, 45, 'R', 17, 93, 14, N'..', 50  )

-- Bảng WareHouses
insert into WareHouses values (N'Nhà kho miền bắc', '123 Đường abc', 1, 500.3)
insert into WareHouses values (N'Nhà kho miền trung', '123 Đường def', 3, 700.3)
insert into WareHouses values (N'Nhà kho miền nam', '123 Đường ghk', 5, 490.3)
GO
-- Bảng Storekeepers
insert into Storekeepers values (1, 3)
insert into Storekeepers values (2, 7)
insert into Storekeepers values (2, 8)
insert into Storekeepers values (3, 10)
insert into Storekeepers values (1, 17)
insert into Storekeepers values (1, 18)
GO

-- Bảng ProductsInStock
--insert into ProductsInStock values (ma kho,ma san pham , so luong)
insert into ProductsInStock values (1,'PAA225/45R19-001' , 20,5 )
insert into ProductsInStock values (1,'PAA225/45R19-002' , 25,6)
insert into ProductsInStock values (1,'PAA225/45R19-003' , 30,6)
insert into ProductsInStock values (1,'PAA225/45R19-004' , 35,65)
insert into ProductsInStock values (1,'PAA225/45R19-005' , 40,65)
insert into ProductsInStock values (1,'PAA225/45R18-001' , 45,65)
insert into ProductsInStock values (1,'PAA225/45R18-002' , 44,65)
insert into ProductsInStock values (1,'PAA225/45R18-003' , 57,65)
insert into ProductsInStock values (1,'PAA225/45R18-004' , 26,65)
insert into ProductsInStock values (1,'PAA225/45R18-005' , 65,65)
insert into ProductsInStock values (1,'PAA225/45R17-001' , 34,65)
insert into ProductsInStock values (1,'PAA225/45R17-002' , 34,65)
insert into ProductsInStock values (1,'PAA225/45R17-003' , 67,65)
insert into ProductsInStock values (1,'PAA225/45R17-004' , 44,65)
insert into ProductsInStock values (1,'PAA225/45R17-005' , 33,65)
GO
insert into ProductsInStock values (2, 'PAA225/45R19-001', 33 ,65)
insert into ProductsInStock values (2, 'PAA225/45R19-002', 45,65)
insert into ProductsInStock values (2, 'PAA225/45R19-003', 35,65)
insert into ProductsInStock values (2, 'PAA225/45R19-004', 67,65)
insert into ProductsInStock values (2, 'PAA225/45R19-005', 44,65)
insert into ProductsInStock values (2, 'PAA225/45R18-001', 33,65)
insert into ProductsInStock values (2, 'PAA225/45R18-002', 65,65)
insert into ProductsInStock values (2, 'PAA225/45R18-003', 33,65)
insert into ProductsInStock values (2, 'PAA225/45R18-004', 64,65)
insert into ProductsInStock values (2, 'PAA225/45R18-005', 33,65)
insert into ProductsInStock values (2, 'PAA225/45R17-001', 65,65)
insert into ProductsInStock values (2, 'PAA225/45R17-002', 33,65)
insert into ProductsInStock values (2, 'PAA225/45R17-003', 75,65)
insert into ProductsInStock values (2, 'PAA225/45R17-004', 33,65)
insert into ProductsInStock values (2, 'PAA225/45R17-005', 77,65)
Go
insert into ProductsInStock values (3,'PAA225/45R19-001' , 76,65)
insert into ProductsInStock values (3,'PAA225/45R19-002' , 33,65)
insert into ProductsInStock values (3,'PAA225/45R19-003' , 22,65)
insert into ProductsInStock values (3,'PAA225/45R19-004' , 44,65)
insert into ProductsInStock values (3,'PAA225/45R19-005' , 46,65)
insert into ProductsInStock values (3,'PAA225/45R18-001' , 33,65)
insert into ProductsInStock values (3,'PAA225/45R18-002' , 22,65)
insert into ProductsInStock values (3,'PAA225/45R18-003' , 65,65)
insert into ProductsInStock values (3,'PAA225/45R18-004' , 33,65)
insert into ProductsInStock values (3,'PAA225/45R18-005' , 22,65)
insert into ProductsInStock values (3,'PAA225/45R17-001' , 55,65)
insert into ProductsInStock values (3,'PAA225/45R17-002' , 33,65)
insert into ProductsInStock values (3,'PAA225/45R17-003' , 65,65)
insert into ProductsInStock values (3,'PAA225/45R17-004' , 33,65)
insert into ProductsInStock values (3,'PAA225/45R17-005' , 66,65)
GO

insert into ProductsInStock values (1,'PBB225/45R19-001' , 20 ,65)
insert into ProductsInStock values (1,'PBB225/45R19-002' , 25,65)
insert into ProductsInStock values (1,'PBB225/45R19-003' , 30,65)
insert into ProductsInStock values (1,'PBB225/45R19-004' , 35,65)
insert into ProductsInStock values (1,'PBB225/45R19-005' , 40,65)
insert into ProductsInStock values (1,'PBB225/45R18-001' , 45,65)
insert into ProductsInStock values (1,'PBB225/45R18-002' , 44,65)
insert into ProductsInStock values (1,'PBB225/45R18-003' , 57,65)
insert into ProductsInStock values (1,'PBB225/45R18-004' , 26,65)
insert into ProductsInStock values (1,'PBB225/45R18-005' , 65,65)
insert into ProductsInStock values (1,'PBB225/45R17-001' , 34,65)
insert into ProductsInStock values (1,'PBB225/45R17-002' , 34,65)
insert into ProductsInStock values (1,'PBB225/45R17-003' , 67,65)
insert into ProductsInStock values (1,'PBB225/45R17-004' , 44,65)
insert into ProductsInStock values (1,'PBB225/45R17-005' , 33,65)
Go
insert into ProductsInStock values (2, 'PBB225/45R19-001', 33 ,65)
insert into ProductsInStock values (2, 'PBB225/45R19-002', 45,65)
insert into ProductsInStock values (2, 'PBB225/45R19-003', 35,65)
insert into ProductsInStock values (2, 'PBB225/45R19-004', 67,65)
insert into ProductsInStock values (2, 'PBB225/45R19-005', 44,65)
insert into ProductsInStock values (2, 'PBB225/45R18-001', 33,65)
insert into ProductsInStock values (2, 'PBB225/45R18-002', 65,65)
insert into ProductsInStock values (2, 'PBB225/45R18-003', 33,65)
insert into ProductsInStock values (2, 'PBB225/45R18-004', 64,65)
insert into ProductsInStock values (2, 'PBB225/45R18-005', 33,65)
insert into ProductsInStock values (2, 'PBB225/45R17-001', 65,65)
insert into ProductsInStock values (2, 'PBB225/45R17-002', 33,65)
insert into ProductsInStock values (2, 'PBB225/45R17-003', 75,65)
insert into ProductsInStock values (2, 'PBB225/45R17-004', 33,65)
insert into ProductsInStock values (2, 'PBB225/45R17-005', 77,65)
Go
insert into ProductsInStock values (3,'PBB225/45R19-001' , 76,65)
insert into ProductsInStock values (3,'PBB225/45R19-002' , 33,65)
insert into ProductsInStock values (3,'PBB225/45R19-003' , 22,65)
insert into ProductsInStock values (3,'PBB225/45R19-004' , 44,65)
insert into ProductsInStock values (3,'PBB225/45R19-005' , 46,65)
insert into ProductsInStock values (3,'PBB225/45R18-001' , 33,65)
insert into ProductsInStock values (3,'PBB225/45R18-002' , 22,65)
insert into ProductsInStock values (3,'PBB225/45R18-003' , 65,65)
insert into ProductsInStock values (3,'PBB225/45R18-004' , 33,65)
insert into ProductsInStock values (3,'PBB225/45R18-005' , 22,65)
insert into ProductsInStock values (3,'PBB225/45R17-001' , 55,65)
insert into ProductsInStock values (3,'PBB225/45R17-002' , 33,65)
insert into ProductsInStock values (3,'PBB225/45R17-003' , 65,65)
insert into ProductsInStock values (3,'PBB225/45R17-004' , 33,65)
insert into ProductsInStock values (3,'PBB225/45R17-005' , 66,65)
GO


insert into ProductsInStock values (1,'PCC225/45R19-001' , 20 ,65)
insert into ProductsInStock values (1,'PCC225/45R19-002' , 25,65)
insert into ProductsInStock values (1,'PCC225/45R19-003' , 30,65)
insert into ProductsInStock values (1,'PCC225/45R19-004' , 35,65)
insert into ProductsInStock values (1,'PCC225/45R19-005' , 40,65)
insert into ProductsInStock values (1,'PCC225/45R18-001' , 45,65)
insert into ProductsInStock values (1,'PCC225/45R18-002' , 44,65)
insert into ProductsInStock values (1,'PCC225/45R18-003' , 57,65)
insert into ProductsInStock values (1,'PCC225/45R18-004' , 26,65)
insert into ProductsInStock values (1,'PCC225/45R18-005' , 65,65)
insert into ProductsInStock values (1,'PCC225/45R17-001' , 34,65)
insert into ProductsInStock values (1,'PCC225/45R17-002' , 34,65)
insert into ProductsInStock values (1,'PCC225/45R17-003' , 67,65)
insert into ProductsInStock values (1,'PCC225/45R17-004' , 44,65)
insert into ProductsInStock values (1,'PCC225/45R17-005' , 33,65)
Go
insert into ProductsInStock values (2, 'PCC225/45R19-001', 33 ,65)
insert into ProductsInStock values (2, 'PCC225/45R19-002', 45,65)
insert into ProductsInStock values (2, 'PCC225/45R19-003', 35,65)
insert into ProductsInStock values (2, 'PCC225/45R19-004', 67,65)
insert into ProductsInStock values (2, 'PCC225/45R19-005', 44,65)
insert into ProductsInStock values (2, 'PCC225/45R18-001', 33,65)
insert into ProductsInStock values (2, 'PCC225/45R18-002', 65,65)
insert into ProductsInStock values (2, 'PCC225/45R18-003', 33,65)
insert into ProductsInStock values (2, 'PCC225/45R18-004', 64,65)
insert into ProductsInStock values (2, 'PCC225/45R18-005', 33,65)
insert into ProductsInStock values (2, 'PCC225/45R17-001', 65,65)
insert into ProductsInStock values (2, 'PCC225/45R17-002', 33,65)
insert into ProductsInStock values (2, 'PCC225/45R17-003', 75,65)
insert into ProductsInStock values (2, 'PCC225/45R17-004', 33,65)
insert into ProductsInStock values (2, 'PCC225/45R17-005', 77,65)
Go
insert into ProductsInStock values (3,'PCC225/45R19-001' , 76,65)
insert into ProductsInStock values (3,'PCC225/45R19-002' , 33,65)
insert into ProductsInStock values (3,'PCC225/45R19-003' , 22,65)
insert into ProductsInStock values (3,'PCC225/45R19-004' , 44,65)
insert into ProductsInStock values (3,'PCC225/45R19-005' , 46,65)
insert into ProductsInStock values (3,'PCC225/45R18-001' , 33,65)
insert into ProductsInStock values (3,'PCC225/45R18-002' , 22,65)
insert into ProductsInStock values (3,'PCC225/45R18-003' , 65,65)
insert into ProductsInStock values (3,'PCC225/45R18-004' , 33,65)
insert into ProductsInStock values (3,'PCC225/45R18-005' , 22,65)
insert into ProductsInStock values (3,'PCC225/45R17-001' , 55,65)
insert into ProductsInStock values (3,'PCC225/45R17-002' , 33,65)
insert into ProductsInStock values (3,'PCC225/45R17-003' , 65,65)
insert into ProductsInStock values (3,'PCC225/45R17-004' , 33,65)
insert into ProductsInStock values (3,'PCC225/45R17-005' , 66,65)
GO


-- Bảng StatusOfPlan
insert into StatusOfPlan values (N'Tạo mới/ Cập nhật', N'Khi tạo hoặc cập nhật kế hoạch')
insert into StatusOfPlan values (N'Chờ xem xét', N'Khi tạo hoặc cập nhật kế hoạch')
insert into StatusOfPlan values (N'Chấp nhận', N'Khi quản lý chấp nhận kế hoạch hoặc cập nhật kế hoạch')
insert into StatusOfPlan values (N'Hủy', N'Khi quản lý không chấp nhận kế hoạch.')
insert into StatusOfPlan values (N'Hoàn Thành', N'Khi kế hoạch đã được hoàn thành.')
GO
-- Bảng Plans
insert into Plans values (13, N'Kế hoạch nhập hàng năm 2011', '7/5/2010', '1/1/2011', 2011,3, '7/5/2010', 1, N'Kế hoạch nhằm mục đích...' )
GO
-- Bảng LogForPlan
insert into LogForPlan values (1, 1, '10/7/2010')
insert into LogForPlan values (1, 2, '17/7/2010')
insert into LogForPlan values (1, 3, '27/7/2010')
GO
-- Bảng ProcessingPlanOfPlan
insert into ProcessingPlanOfPlan values (N'Title - xử lý kế hoạch năm 2011 của manager ...',N'Nội dung nhận xét ...','27/5/2010', 11 , 1 )
GO
-- Bảng PlanDetailsOfWareHouse
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PAA225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PAA225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PAA225/45R17-002', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PBB225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PBB225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PBB225/45R17-002', 40)
Go

-- CC
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'PCC225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'PCC225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'PCC225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TAA225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TAA225/45R17-002', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,1,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,1,4,'TBB225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,2,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,2,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,2,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,2,4,'TBB225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,3,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,3,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (1,3,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (1,3,4,'TBB225/45R17-002', 40)
Go

-- CC
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (1,1,1,'TCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (1,1,2,'TCC225/45R17-002', 20)


insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PAA225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PAA225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PAA225/45R17-002', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PBB225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PBB225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PBB225/45R17-002', 40)
Go

-- CC
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'PCC225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'PCC225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'PCC225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TAA225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TAA225/45R17-002', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,1,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,1,4,'TBB225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,2,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,2,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,2,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,2,4,'TBB225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,3,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,3,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (2,3,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R18-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R18-002', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (2,3,4,'TBB225/45R17-002', 40)
Go

--LogForPlan 2
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R18-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (2,1,1,'TCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R18-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (2,1,2,'TCC225/45R17-002', 20)

-- lan cap nhat du lieu thu 3
insert into PlanDetailsOfWareHouse values (3,1,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PAA225/45R19-005', 10)

insert into PlanDetailsOfWareHouse values (3,1,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PAA225/45R19-005', 20)

insert into PlanDetailsOfWareHouse values (3,1,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (3,1,4,'PAA225/45R19-001', 40)
Go
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PAA225/45R18-001', 10)

insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PAA225/45R18-001', 20)

insert into PlanDetailsOfWareHouse values (3,2,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,2,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PAA225/45R19-005', 40)
Go

insert into PlanDetailsOfWareHouse values (3,3,1,'PAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PAA225/45R19-005', 10)

insert into PlanDetailsOfWareHouse values (3,3,2,'PAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PAA225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PAA225/45R19-005', 20)

insert into PlanDetailsOfWareHouse values (3,3,3,'PAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PAA225/45R19-005', 30)

insert into PlanDetailsOfWareHouse values (3,3,4,'PAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PAA225/45R19-004', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (3,1,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PBB225/45R19-005', 10)

insert into PlanDetailsOfWareHouse values (3,1,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PBB225/45R18-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PBB225/45R19-005', 40)
GO
insert into PlanDetailsOfWareHouse values (3,2,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,2,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PBB225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,2,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PBB225/45R18-002', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PBB225/45R18-003', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,2,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PBB225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,3,2,'PBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,3,3,'PBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PBB225/45R17-002', 40)
Go

-- CC
insert into PlanDetailsOfWareHouse values (3,1,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,1,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'PCC225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (3,2,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,2,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,2,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'PCC225/45R19-004', 30)

insert into PlanDetailsOfWareHouse values (3,2,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PCC225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'PCC225/45R17-002', 40)
Go

insert into PlanDetailsOfWareHouse values (3,3,1,'PCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PCC225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'PCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,3,2,'PCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PCC225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'PCC225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'PCC225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,3,4,'PCC225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PCC225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PCC225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'PCC225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (3,1,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TAA225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,1,2,'TAA225/45R18-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TAA225/45R18-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TAA225/45R17-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TAA225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TAA225/45R17-002', 40)
Go
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,2,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TAA225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TAA225/45R19-004', 20)

insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R19-005', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,2,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TAA225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TAA225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (3,3,1,'TAA225/45R18-002', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TAA225/45R18-003', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TAA225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TAA225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,3,2,'TAA225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TAA225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TAA225/45R19-003', 20)

insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TAA225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R18-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TAA225/45R17-002', 40)
Go
-- BB
insert into PlanDetailsOfWareHouse values (3,1,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R19-003', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R19-004', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,1,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,1,4,'TBB225/45R17-002', 40)
GO
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R17-001', 10)
insert into PlanDetailsOfWareHouse values (3,2,1,'TBB225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (3,2,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,2,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,2,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R19-005', 40)
insert into PlanDetailsOfWareHouse values (3,2,4,'TBB225/45R18-001', 40)
Go

insert into PlanDetailsOfWareHouse values (3,3,1,'TBB225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TBB225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TBB225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TBB225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,3,1,'TBB225/45R19-005', 10)

insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R19-005', 20)
insert into PlanDetailsOfWareHouse values (3,3,2,'TBB225/45R17-002', 20)

insert into PlanDetailsOfWareHouse values (3,3,3,'TBB225/45R19-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TBB225/45R19-002', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TBB225/45R17-001', 30)
insert into PlanDetailsOfWareHouse values (3,3,3,'TBB225/45R17-002', 30)

insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R19-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R19-002', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R19-003', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R19-004', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R17-001', 40)
insert into PlanDetailsOfWareHouse values (3,3,4,'TBB225/45R17-002', 40)
Go

-- CC
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R19-001', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R19-002', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R19-003', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R19-004', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R19-005', 10)
insert into PlanDetailsOfWareHouse values (3,1,1,'TCC225/45R17-002', 10)

insert into PlanDetailsOfWareHouse values (3,1,2,'TCC225/45R19-001', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TCC225/45R19-002', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TCC225/45R19-003', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TCC225/45R19-004', 20)
insert into PlanDetailsOfWareHouse values (3,1,2,'TCC225/45R19-005', 20)

-- Bảng PlanAssessmentReports
insert into PlanAssessmentReports values (13, N'Báo cáo đánh giá kế hoạch cuối năm 2010', N'Noi dung báo cáo đánh giá', '2/2/2011', 1)

insert into PlanAssessmentReports values (13, N'Báo cáo đánh giá kế hoạch cuối năm 2010', N'Noi dung báo cáo đánh giá', '5/6/2011', 1)
Go
-- Bảng EvaluationPlanAssessmentReports
--insert into EvaluationPlanAssessmentReports values ()

-- Bảng StatusOfContract
insert into StatusOfContract values (N'Tạo mới/ Cập nhật',N'Khi ban điều phối mới đưa ra hợp đồng nhưng chưa đề nghị lên cho ban quản lý xem xét');
insert into StatusOfContract values (N'Chờ xem xét', N'Khi ban điều phối đề xuất lên ban quản lí xem xét.');
insert into StatusOfContract values (N'Chấp nhận', N'Khi ban quản lý chấp nhận hợp đồng mua hàng.');
insert into StatusOfContract values (N'Hủy',  N'Ban quản lý không chấp nhận hợp đồng mua hàng.');
Go
-- Bảng PurchaseContracts
-- insert into PurchaseContracts values ()
-- insert into PurchaseContracts values ()

-- Bảng ContractDetails
-- insert into ContractDetails values ()

-- Bảng DeliveryMethods

-- Bảng DeliveryMethodDetails

-- Bảng StatusOfInvoices
insert into StatusOfInvoices values (N'Tạo mới/ cập nhật', N'Ban điều phối dựa vào hợp đồng để thành lập hóa đơn mua hàng.');
insert into StatusOfInvoices values (N'Chờ xem xét', N'Sau khi đã tính toán hóa đơn mua hàng, ban điều phối đề xuất lên ban quản lý.');
insert into StatusOfInvoices values (N'Chấp nhận',N'Ban quản lí xem xét và chấp nhận hóa đơn.');
insert into StatusOfInvoices values (N'Hủy',N'Ban quản lý xem xét và không chấp nhận hóa đơn do ban điều phối đưa lên.');
insert into StatusOfInvoices values (N'Đã nhận hàng',N'Sau khi hóa đơn được thanh toán với nhà cung cấp, nhà cung cấp sẽ chuyển hàng, trạng thái sẽ được kích hoạt.');
GO

-- Bảng PurchaseInvoices


-- Bảng PurchaseInvoiceDetails

-- Bảng StatusOfOrder
insert into StatusOfOrder values (N'Tạo mới/ cập nhật', N'Khi đại lí vừa đặt hàng xong với công ty.')
insert into StatusOfOrder values (N'Chờ xem xét', N'Đơn đặt hàng được chờ HO xem xét xử lý.')
insert into StatusOfOrder values (N'Hủy hàng', N'Đại lý có quyền hủy hàng với công ty.')
insert into StatusOfOrder values (N'Chấp nhận', N'HO chấp nhận đơn đặt hàng của đại lý.')
insert into StatusOfOrder values (N'Từ chối', N'HO không chấp nhận đơn đặt hàng.')
insert into StatusOfOrder values (N'Đã nhận hàng', N'Đại lí đã nhận hàng, đơn hàng đã kết thúc.')
GO

-- Bảng Orders
insert into Orders(DealerID,Address,CityID,RequireDate, IsProcessed,StatusOfOrderID) values(3, N'Địa chi nơi nhận hàng', 1,'2/2/2009','true',6 );
insert into Orders(DealerID,Address,CityID,RequireDate, IsProcessed,StatusOfOrderID) values(3, N'Địa chi nơi nhận hàng', 1,'4/4/2009','true',6 );

-- Bảng ProcessingOrders

-- Bảng Prices

-- Bảng OrderDetails

insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R19-001',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R19-002',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R19-003',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R17-001',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R17-005',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R19-001',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R19-003',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R18-004',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R17-001',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PCC225/45R19-003',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PCC225/45R19-002',5,1,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PCC225/45R19-005',5,1,30000,150000);
GO
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R19-001',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PAA225/45R19-002',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R19-001',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R19-003',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R18-004',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PBB225/45R17-001',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PCC225/45R19-005',5,2,30000,150000);
insert into OrderDetails (WheelDetailDI,Amount,OrderID,CurrentUnitPrice,TotalMoney)values('PCC225/45R19-002',5,2,30000,150000);

-- Bảng OrderInvoices
insert into OrderInvoices(OrderInvoiceID, OrderID, PreTotalMoney, tax, Discount,TotalMoney,WritingDate,IsWritingExwarehouseVotes) values ('OI1', 1,1800000, 10, 0, 198, '3/3/2009', 'true' )
insert into OrderInvoices(OrderInvoiceID, OrderID, PreTotalMoney, tax, Discount,TotalMoney,WritingDate,IsWritingExwarehouseVotes) values ('OI2', 2,1200000, 10, 0, 132, '5/5/2009', 'true' )

-- Bảng RequestingForCoordinators

-- Bảng UpdatingOrders

-- Bảng StatusOfRequest
insert into StatusOfRequest values (N'Tạo mới/ cập nhật',N'Khi HO yêu cầu một lượng hàng với ban điều phối')
insert into StatusOfRequest values (N'Chờ xem xét',N'HO đưa phiếu yêu cầu nguồn hàng và chờ ban điều phối xử lý.')
insert into StatusOfRequest values (N'Chấp nhận',N'Ban điều phối chấp nhận việc yêu cầu nguồn hàng.')
insert into StatusOfRequest values (N'Hủy',N'Không chấp nhận yêu cầu nguồn hàng.')
Go

-- Bảng SourcingRequest
insert into SourcingRequest(SourcingRequestID,EmployeeID,RequestDate,RequirementDate ,StatusOfRequestID ) values ('SR1',4, '2/2/2010','4/4/2010',1 );
insert into SourcingRequest(SourcingRequestID,EmployeeID,RequestDate,RequirementDate ,StatusOfRequestID ) values ('SR2',5, '2/3/2010','4/5/2010',1 );
insert into SourcingRequest(SourcingRequestID,EmployeeID,RequestDate,RequirementDate ,StatusOfRequestID ) values ('SR3',6, '4/3/2010','6/5/2010',1 );

insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-001',5,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-002',5,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-003',5,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-004',5,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-005',40,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-001',45,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-002',44,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-003',57,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-004',26,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-005',65,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R17-001',34,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R17-002',34,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R17-003',67,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R17-004',44,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R17-005',33,'SR1');

insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-001',20,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-002',25,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-003',30,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-004',35,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-005',40,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-001',45,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-002',44,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-003',57,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-004',26,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-005',33,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-004',44,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-003',67,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-002',34,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-001',34,'SR2');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-005',65,'SR2');

insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-002',44,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-003',57,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-004',26,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-005',33,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-004',44,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-003',67,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-002',34,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R17-001',34,'SR1');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-005',65,'SR1');

insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-001',20,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-002',25,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-003',30,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-004',35,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R19-005',40,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PBB225/45R18-001',45,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R18-004' , 26,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R18-003' , 57,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R18-002' , 44,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R18-001' , 45,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R19-005' , 40,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R19-004' , 35,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R19-003' , 30,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R19-002' , 25,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PCC225/45R19-001' , 20 ,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-003',5,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-004',5,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R19-005',40,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-001',45,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-002',44,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-003',57,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-004',26,'SR3');
insert into RequestingDetails(WheelDetailID,Amount,SourcingRequestID) values('PAA225/45R18-005',65,'SR3');

-- Bảng StatusOfTransferingRequest
insert into StatusOfTransferingRequest values (N'Tạo mới/ cập nhật',N'')
insert into StatusOfTransferingRequest values (N'Chờ xem xét',N'Đợi manager thông qua')
insert into StatusOfTransferingRequest values (N'Chấp nhận',N'Được manager thông qua')
insert into StatusOfTransferingRequest values (N'Hủy',N'Không được manager thông qua')
insert into StatusOfTransferingRequest values (N'Đang chuyển hàng',N'Trạng thái này được thiết lập khi thủ kho của bên xuất hàng xác nhận việc xuất hàng.')
insert into StatusOfTransferingRequest values (N'Đã nhận hàng',N' (Hoàn thành) - Khi thủ kho của bên kho nhập đã nhận được hàng')
Go
-- Bảng TransferingRequest
insert into TransferingRequest(TransferingRequestID,EmployeeID,ToWarehouseID, WritingDate,RequirementDate,StatusOfTransferingRequestID ) values ('TR1',4,1, '3/2/2010','5/4/2010',1 );

-- Bảng RequestingDetails
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R19-001',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R19-002',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R19-003',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R19-004',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R19-005',4,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R18-001',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R18-002',4,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R18-003',7,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R18-004',6,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R18-005',5,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R17-001',4,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R17-002',4,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R17-003',6,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R17-004',4,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PAA225/45R17-005',3,2,'TR1');

insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R19-001',20,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R19-002',25,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R19-003',30,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R19-004',35,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R19-005',40,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PBB225/45R18-001',45,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R18-004', 26,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R18-003' , 57,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R18-002' , 44,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R18-001' , 45,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R19-005' , 40,2,'TR1');
insert into RequestingDetailsForTransfering(WheelDetailID,Amount,FromWarehouseID,TransferingRequestID) values('PCC225/45R19-004' , 35,2,'TR1');

-- Bảng ActionOnStock
insert into ActionOnStock values (N'Nhập kho', N'Nhập kho')
insert into ActionOnStock values (N'Xuất kho', N'Xuất kho')
GO
-- Bảng LogForStock

insert LogForStock(ActionOnStockID,WareHouseID,OrderInvoiceID, EmployeeID,IsApproved,WritingDate) values(2,1,'OI1', 3, 'true', '4/6/2009' )
insert LogForStock(ActionOnStockID,WareHouseID,OrderInvoiceID, EmployeeID,IsApproved,WritingDate) values(2,1,'OI2', 3, 'true', '5/6/2009' )
-- Bảng LogDetailsForStock

insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PAA225/45R19-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PAA225/45R19-002', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PAA225/45R19-003', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PAA225/45R17-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PAA225/45R17-005', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PBB225/45R19-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PBB225/45R19-003', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PBB225/45R18-004', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PBB225/45R17-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PCC225/45R19-003', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PCC225/45R19-002', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(1, 'PCC225/45R19-005', 5,5, 30000, 10, 30000);
 GO
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PAA225/45R19-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PAA225/45R19-002', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PBB225/45R19-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PBB225/45R19-003', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PBB225/45R18-004', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PBB225/45R17-001', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PCC225/45R19-005', 5,5, 30000, 10, 30000);
insert LogDetailsForStock(LogForStockID,WheelDetailID,InvoiceAmount,RealAmount,UnitPrice,AmountOfInventory,UnitPriceOfInventory) values(2, 'PCC225/45R19-002', 5,5, 30000, 10, 30000);

-- Bảng TypesOfReport

-- Bảng Reports

-- Bảng EvaluationReports



